/ Programmer Plus 2007 / Programmer-Plus-2007.iso / Programming / SQL and Data Base / Logic Works ERwin 3.5 / data.1 / ERTMPL32.DLL / RCDATA / 2324

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 43 55 53 54 4f 4d 20 54 | 52 49 47 47 45 52 20 44 |CUSTOM T|RIGGER D|
|00000010| 45 46 41 55 4c 54 20 42 | 4f 44 59 00 25 44 65 63 |EFAULT B|ODY.%Dec|
|00000020| 6c 28 69 2c 31 29 0d 0a | 25 46 6f 72 45 61 63 68 |l(i,1)..|%ForEach|
|00000030| 50 61 72 65 6e 74 52 65 | 6c 28 29 20 7b 0d 0a 25 |ParentRe|l() {..%|
|00000040| 49 66 28 25 52 65 6c 54 | 65 6d 70 6c 61 74 65 29 |If(%RelT|emplate)|
|00000050| 0d 0a 7b 63 72 65 61 74 | 65 20 74 72 69 67 67 65 |..{creat|e trigge|
|00000060| 72 20 25 54 72 69 67 67 | 65 72 4e 61 6d 65 25 49 |r %Trigg|erName%I|
|00000070| 66 28 25 3c 3e 28 25 3a | 69 2c 31 29 29 7b 25 3a |f(%<>(%:|i,1)){%:|
|00000080| 69 7d 0d 0a 20 20 25 46 | 69 72 65 20 25 41 63 74 |i}..  %F|ire %Act|
|00000090| 69 6f 6e 0d 0a 20 20 6f | 6e 20 25 54 61 62 6c 65 |ion..  o|n %Table|
|000000a0| 4e 61 6d 65 0d 0a 20 20 | 25 52 65 66 43 6c 61 75 |Name..  |%RefClau|
|000000b0| 73 65 0d 0a 20 20 25 53 | 63 6f 70 65 0d 0a 20 20 |se..  %S|cope..  |
|000000c0| 25 52 65 6c 54 65 6d 70 | 6c 61 74 65 0d 0a 20 20 |%RelTemp|late..  |
|000000d0| 25 44 42 4d 53 54 72 69 | 67 67 65 72 44 65 6c 69 |%DBMSTri|ggerDeli|
|000000e0| 6d 0d 0a 20 20 25 3d 28 | 69 2c 25 2b 28 25 3a 69 |m..  %=(|i,%+(%:i|
|000000f0| 2c 31 29 29 0d 0a 7d 7d | 0d 0a 0d 0a 25 46 6f 72 |,1))..}}|....%For|
|00000100| 45 61 63 68 43 68 69 6c | 64 52 65 6c 28 29 20 7b |EachChil|dRel() {|
|00000110| 0d 0a 25 49 66 28 25 52 | 65 6c 54 65 6d 70 6c 61 |..%If(%R|elTempla|
|00000120| 74 65 29 0d 0a 7b 63 72 | 65 61 74 65 20 74 72 69 |te)..{cr|eate tri|
|00000130| 67 67 65 72 20 25 54 72 | 69 67 67 65 72 4e 61 6d |gger %Tr|iggerNam|
|00000140| 65 25 49 66 28 25 3c 3e | 28 25 3a 69 2c 31 29 29 |e%If(%<>|(%:i,1))|
|00000150| 7b 25 3a 69 7d 0d 0a 20 | 20 25 46 69 72 65 20 25 |{%:i}.. | %Fire %|
|00000160| 41 63 74 69 6f 6e 0d 0a | 20 20 6f 6e 20 25 54 61 |Action..|  on %Ta|
|00000170| 62 6c 65 4e 61 6d 65 0d | 0a 20 20 25 52 65 66 43 |bleName.|.  %RefC|
|00000180| 6c 61 75 73 65 0d 0a 20 | 20 25 53 63 6f 70 65 0d |lause.. | %Scope.|
|00000190| 0a 20 20 25 52 65 6c 54 | 65 6d 70 6c 61 74 65 0d |.  %RelT|emplate.|
|000001a0| 0a 20 20 25 44 42 4d 53 | 54 72 69 67 67 65 72 44 |.  %DBMS|TriggerD|
|000001b0| 65 6c 69 6d 0d 0a 20 20 | 25 3d 28 69 2c 25 2b 28 |elim..  |%=(i,%+(|
|000001c0| 25 3a 69 2c 31 29 29 0d | 0a 7d 7d 0d 0a 00 30 27 |%:i,1)).|.}}...0'|
+--------+-------------------------+-------------------------+--------+--------+